package edu.lsnu.equipment_management_system.mapper;

import edu.lsnu.equipment_management_system.pojo.po.entity.UserTablePo;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * @author mzy
 * @Description
 * @date 2018/11/27
 */
public interface UpdateDefaultPasswordMapper {
    @Select("select YHB.ZGH 'userNo' from YHB")
    List<UserTablePo> selectAll();

    @Update("update YHB set YHB.MD5 = #{password} where ZGH = #{userNo}")
    void updateUserPassword(UserTablePo userTablePo);
}
